/* AD_Sequence_No */

/* Day */
ALTER TABLE AD_SEQUENCE_NO ADD DAY NVARCHAR2(2) DEFAULT '00' NOT NULL;

INSERT INTO AD_ELEMENT ( AD_ELEMENT_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY,
UPDATED, UPDATEDBY, COLUMNNAME, ENTITYTYPE, NAME, PRINTNAME, DESCRIPTION, HELP, PO_NAME,
PO_PRINTNAME, PO_DESCRIPTION, PO_HELP ) VALUES ( 
53200, 0, 0, 'Y',  TO_Date( '02/08/2007 10:49:28', 'MM/DD/YYYY HH:MI:SS')
, 0,  TO_Date( '02/08/2007 10:49:28', 'MM/DD/YYYY HH:MI:SS'), 0, 'Day', 'D'
, 'Day', 'Day', NULL, NULL, NULL, NULL, NULL, NULL); 

INSERT INTO AD_COLUMN ( AD_COLUMN_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, UPDATED,
CREATEDBY, UPDATEDBY, NAME, DESCRIPTION, HELP, VERSION, ENTITYTYPE, COLUMNNAME, AD_TABLE_ID,
AD_REFERENCE_ID, AD_REFERENCE_VALUE_ID, AD_VAL_RULE_ID, FIELDLENGTH, DEFAULTVALUE, ISKEY, ISPARENT,
ISMANDATORY, ISUPDATEABLE, READONLYLOGIC, ISIDENTIFIER, SEQNO, ISTRANSLATED, ISENCRYPTED, CALLOUT,
VFORMAT, VALUEMIN, VALUEMAX, ISSELECTIONCOLUMN, AD_ELEMENT_ID, AD_PROCESS_ID, ISSYNCDATABASE,
ISALWAYSUPDATEABLE, COLUMNSQL ) VALUES ( 
53200, 0, 0, 'Y',  TO_Date( '02/08/2007 10:50:10', 'MM/DD/YYYY HH:MI:SS')
,  TO_Date( '02/08/2007 06:10:47', 'MM/DD/YYYY HH:MI:SS'), 0, 0, 'Day', NULL
, NULL, 0, 'D', 'Day', 122, 10, NULL, NULL, 2, NULL, 'N', 'Y', 'Y', 'N', NULL, 'N'
, 0, 'N', 'N', NULL, NULL, NULL, NULL, 'N', 53200
, NULL, 'N', 'N', NULL); 


/* Month */
ALTER TABLE AD_SEQUENCE_NO ADD MONTH NVARCHAR2(2) DEFAULT '00' NOT NULL;

INSERT INTO AD_ELEMENT ( AD_ELEMENT_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY,
UPDATED, UPDATEDBY, COLUMNNAME, ENTITYTYPE, NAME, PRINTNAME, DESCRIPTION, HELP, PO_NAME,
PO_PRINTNAME, PO_DESCRIPTION, PO_HELP ) VALUES ( 
53201, 0, 0, 'Y',  TO_Date( '02/08/2007 10:50:55', 'MM/DD/YYYY HH:MI:SS')
, 0,  TO_Date( '02/08/2007 10:50:55', 'MM/DD/YYYY HH:MI:SS'), 0, 'Month', 'D'
, 'Month', 'Month', NULL, NULL, NULL, NULL, NULL, NULL); 

INSERT INTO AD_COLUMN ( AD_COLUMN_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, UPDATED,
CREATEDBY, UPDATEDBY, NAME, DESCRIPTION, HELP, VERSION, ENTITYTYPE, COLUMNNAME, AD_TABLE_ID,
AD_REFERENCE_ID, AD_REFERENCE_VALUE_ID, AD_VAL_RULE_ID, FIELDLENGTH, DEFAULTVALUE, ISKEY, ISPARENT,
ISMANDATORY, ISUPDATEABLE, READONLYLOGIC, ISIDENTIFIER, SEQNO, ISTRANSLATED, ISENCRYPTED, CALLOUT,
VFORMAT, VALUEMIN, VALUEMAX, ISSELECTIONCOLUMN, AD_ELEMENT_ID, AD_PROCESS_ID, ISSYNCDATABASE,
ISALWAYSUPDATEABLE, COLUMNSQL ) VALUES ( 
53201, 0, 0, 'Y',  TO_Date( '02/08/2007 10:51:12', 'MM/DD/YYYY HH:MI:SS')
,  TO_Date( '02/08/2007 06:10:53', 'MM/DD/YYYY HH:MI:SS'), 0, 0, 'Month', NULL
, NULL, 0, 'D', 'Month', 122, 10, NULL, NULL, 2, NULL, 'N', 'Y', 'Y', 'N', NULL, 'N'
, 0, 'N', 'N', NULL, NULL, NULL, NULL, 'N', 53201
, NULL, 'N', 'N', NULL); 


ALTER TABLE AD_Sequence_No DROP CONSTRAINT AD_SEQUENCE_NO_KEY;

DROP INDEX AD_SEQUENCE_NO_KEY;

CREATE UNIQUE INDEX AD_SEQUENCE_NO_KEY ON AD_SEQUENCE_NO
(AD_SEQUENCE_ID, CALENDARYEAR, MONTH, DAY);

ALTER TABLE AD_SEQUENCE_NO MODIFY (
  CONSTRAINT AD_SEQUENCE_NO_KEY PRIMARY KEY (AD_SEQUENCE_ID, CALENDARYEAR, MONTH, DAY));

/* ================================================================================================= */
/* AD_Sequence */

/* DateTrx */
ALTER Table AD_Sequence ADD DateTrx DATE;

INSERT INTO AD_COLUMN ( AD_COLUMN_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, UPDATED,
CREATEDBY, UPDATEDBY, NAME, DESCRIPTION, HELP, VERSION, ENTITYTYPE, COLUMNNAME, AD_TABLE_ID,
AD_REFERENCE_ID, AD_REFERENCE_VALUE_ID, AD_VAL_RULE_ID, FIELDLENGTH, DEFAULTVALUE, ISKEY, ISPARENT,
ISMANDATORY, ISUPDATEABLE, READONLYLOGIC, ISIDENTIFIER, SEQNO, ISTRANSLATED, ISENCRYPTED, CALLOUT,
VFORMAT, VALUEMIN, VALUEMAX, ISSELECTIONCOLUMN, AD_ELEMENT_ID, AD_PROCESS_ID, ISSYNCDATABASE,
ISALWAYSUPDATEABLE, COLUMNSQL ) VALUES ( 
53202, 0, 0, 'Y',  TO_Date( '02/08/2007 10:35:41', 'MM/DD/YYYY HH:MI:SS')
,  TO_Date( '02/08/2007 10:40:27', 'MM/DD/YYYY HH:MI:SS'), 0, 0, 'Transaction Date'
, 'Transaction Date', 'The Transaction Date indicates the date of the transaction.'
, 1, 'D', 'DateTrx', 115, 15, NULL, NULL, 7, '@#DATE@', 'N', 'N', 'N', 'Y', NULL, 'N'
, 0, 'N', 'N', NULL, NULL, NULL, NULL, 'N', 1297, NULL, 'N', 'N', NULL);


/* IsAddDate */
ALTER TABLE AD_SEQUENCE ADD IsAddDate CHAR(1) DEFAULT 'N' CHECK (IsAddDate IN ('Y','N'));

INSERT INTO AD_ELEMENT ( AD_ELEMENT_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY,
UPDATED, UPDATEDBY, COLUMNNAME, ENTITYTYPE, NAME, PRINTNAME, DESCRIPTION, HELP, PO_NAME,
PO_PRINTNAME, PO_DESCRIPTION, PO_HELP ) VALUES ( 
53203, 0, 0, 'Y',  TO_Date( '02/08/2007 02:11:37', 'MM/DD/YYYY HH:MI:SS')
, 0,  TO_Date( '02/08/2007 02:15:05', 'MM/DD/YYYY HH:MI:SS'), 0, 'IsAddDate'
, 'D', 'Add Date', 'Add Date', NULL, NULL, NULL, NULL, NULL, NULL); 

INSERT INTO AD_COLUMN ( AD_COLUMN_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, UPDATED,
CREATEDBY, UPDATEDBY, NAME, DESCRIPTION, HELP, VERSION, ENTITYTYPE, COLUMNNAME, AD_TABLE_ID,
AD_REFERENCE_ID, AD_REFERENCE_VALUE_ID, AD_VAL_RULE_ID, FIELDLENGTH, DEFAULTVALUE, ISKEY, ISPARENT,
ISMANDATORY, ISUPDATEABLE, READONLYLOGIC, ISIDENTIFIER, SEQNO, ISTRANSLATED, ISENCRYPTED, CALLOUT,
VFORMAT, VALUEMIN, VALUEMAX, ISSELECTIONCOLUMN, AD_ELEMENT_ID, AD_PROCESS_ID, ISSYNCDATABASE,
ISALWAYSUPDATEABLE, COLUMNSQL ) VALUES ( 
53203, 0, 0, 'Y',  TO_Date( '02/08/2007 02:12:10', 'MM/DD/YYYY HH:MI:SS')
,  TO_Date( '02/08/2007 02:15:09', 'MM/DD/YYYY HH:MI:SS'), 0, 0, 'Add Date'
, NULL, NULL, 1, 'D', 'IsAddDate', 115, 20, NULL, NULL, 1, '''N''', 'N', 'N', 'N'
, 'Y', NULL, 'N', 0, 'N', 'N', NULL, NULL, NULL, NULL, 'N', 53203
, NULL, 'N', 'N', NULL); 


/* IsAddMonth */
ALTER TABLE AD_SEQUENCE ADD IsAddMonth CHAR(1) DEFAULT 'N' CHECK (IsAddMonth IN ('Y','N'));

INSERT INTO AD_ELEMENT ( AD_ELEMENT_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY,
UPDATED, UPDATEDBY, COLUMNNAME, ENTITYTYPE, NAME, PRINTNAME, DESCRIPTION, HELP, PO_NAME,
PO_PRINTNAME, PO_DESCRIPTION, PO_HELP ) VALUES ( 
53204, 0, 0, 'Y',  TO_Date( '02/08/2007 02:13:51', 'MM/DD/YYYY HH:MI:SS')
, 0,  TO_Date( '02/08/2007 02:14:08', 'MM/DD/YYYY HH:MI:SS'), 0, 'IsAddMonth'
, 'D', 'Add Month', 'Add Month', NULL, NULL, NULL, NULL, NULL, NULL); 

INSERT INTO AD_COLUMN ( AD_COLUMN_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, UPDATED,
CREATEDBY, UPDATEDBY, NAME, DESCRIPTION, HELP, VERSION, ENTITYTYPE, COLUMNNAME, AD_TABLE_ID,
AD_REFERENCE_ID, AD_REFERENCE_VALUE_ID, AD_VAL_RULE_ID, FIELDLENGTH, DEFAULTVALUE, ISKEY, ISPARENT,
ISMANDATORY, ISUPDATEABLE, READONLYLOGIC, ISIDENTIFIER, SEQNO, ISTRANSLATED, ISENCRYPTED, CALLOUT,
VFORMAT, VALUEMIN, VALUEMAX, ISSELECTIONCOLUMN, AD_ELEMENT_ID, AD_PROCESS_ID, ISSYNCDATABASE,
ISALWAYSUPDATEABLE, COLUMNSQL ) VALUES ( 
53204, 0, 0, 'Y',  TO_Date( '02/08/2007 02:14:36', 'MM/DD/YYYY HH:MI:SS')
,  TO_Date( '02/08/2007 02:14:36', 'MM/DD/YYYY HH:MI:SS'), 0, 0, 'Add Month'
, NULL, NULL, 1, 'D', 'IsAddMonth', 115, 20, NULL, NULL, 1, '''N''', 'N', 'N', 'N'
, 'Y', NULL, 'N', 0, 'N', 'N', NULL, NULL, NULL, NULL, 'N', 53204
, NULL, 'N', 'N', NULL); 


/* IsAddYear */
ALTER TABLE AD_SEQUENCE ADD IsAddYear CHAR(1) DEFAULT 'N' CHECK (IsAddYear IN ('Y','N'));

INSERT INTO AD_ELEMENT ( AD_ELEMENT_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY,
UPDATED, UPDATEDBY, COLUMNNAME, ENTITYTYPE, NAME, PRINTNAME, DESCRIPTION, HELP, PO_NAME,
PO_PRINTNAME, PO_DESCRIPTION, PO_HELP ) VALUES ( 
53205, 0, 0, 'Y',  TO_Date( '02/08/2007 02:16:03', 'MM/DD/YYYY HH:MI:SS')
, 0,  TO_Date( '02/08/2007 02:16:03', 'MM/DD/YYYY HH:MI:SS'), 0, 'IsAddYear'
, 'D', 'Add Year', 'Add Year', NULL, NULL, NULL, NULL, NULL, NULL); 

INSERT INTO AD_COLUMN ( AD_COLUMN_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, UPDATED,
CREATEDBY, UPDATEDBY, NAME, DESCRIPTION, HELP, VERSION, ENTITYTYPE, COLUMNNAME, AD_TABLE_ID,
AD_REFERENCE_ID, AD_REFERENCE_VALUE_ID, AD_VAL_RULE_ID, FIELDLENGTH, DEFAULTVALUE, ISKEY, ISPARENT,
ISMANDATORY, ISUPDATEABLE, READONLYLOGIC, ISIDENTIFIER, SEQNO, ISTRANSLATED, ISENCRYPTED, CALLOUT,
VFORMAT, VALUEMIN, VALUEMAX, ISSELECTIONCOLUMN, AD_ELEMENT_ID, AD_PROCESS_ID, ISSYNCDATABASE,
ISALWAYSUPDATEABLE, COLUMNSQL ) VALUES ( 
53205, 0, 0, 'Y',  TO_Date( '02/08/2007 02:16:26', 'MM/DD/YYYY HH:MI:SS')
,  TO_Date( '02/08/2007 02:16:26', 'MM/DD/YYYY HH:MI:SS'), 0, 0, 'Add Year'
, NULL, NULL, 1, 'D', 'IsAddYear', 115, 20, NULL, NULL, 1, '''N''', 'N', 'N', 'N'
, 'Y', NULL, 'N', 0, 'N', 'N', NULL, NULL, NULL, NULL, 'N', 53205
, NULL, 'N', 'N', NULL); 


/* IsRomanCharacter */
ALTER TABLE AD_SEQUENCE ADD IsRomanCharacter CHAR(1) DEFAULT 'N' CHECK (IsRomanCharacter IN ('Y','N'));

INSERT INTO AD_ELEMENT ( AD_ELEMENT_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY,
UPDATED, UPDATEDBY, COLUMNNAME, ENTITYTYPE, NAME, PRINTNAME, DESCRIPTION, HELP, PO_NAME,
PO_PRINTNAME, PO_DESCRIPTION, PO_HELP ) VALUES ( 
53206, 0, 0, 'Y',  TO_Date( '02/08/2007 02:17:42', 'MM/DD/YYYY HH:MI:SS')
, 0,  TO_Date( '02/08/2007 02:17:42', 'MM/DD/YYYY HH:MI:SS'), 0, 'IsRomanCharacter'
, 'D', 'Use Roman Character', 'Use Roman Character', NULL, NULL, NULL, NULL, NULL
, NULL); 

INSERT INTO AD_COLUMN ( AD_COLUMN_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, UPDATED,
CREATEDBY, UPDATEDBY, NAME, DESCRIPTION, HELP, VERSION, ENTITYTYPE, COLUMNNAME, AD_TABLE_ID,
AD_REFERENCE_ID, AD_REFERENCE_VALUE_ID, AD_VAL_RULE_ID, FIELDLENGTH, DEFAULTVALUE, ISKEY, ISPARENT,
ISMANDATORY, ISUPDATEABLE, READONLYLOGIC, ISIDENTIFIER, SEQNO, ISTRANSLATED, ISENCRYPTED, CALLOUT,
VFORMAT, VALUEMIN, VALUEMAX, ISSELECTIONCOLUMN, AD_ELEMENT_ID, AD_PROCESS_ID, ISSYNCDATABASE,
ISALWAYSUPDATEABLE, COLUMNSQL ) VALUES ( 
53206, 0, 0, 'Y',  TO_Date( '02/08/2007 02:18:01', 'MM/DD/YYYY HH:MI:SS')
,  TO_Date( '02/08/2007 02:18:01', 'MM/DD/YYYY HH:MI:SS'), 0, 0, 'Use Roman Character'
, NULL, NULL, 1, 'D', 'IsRomanCharacter', 115, 20, NULL, NULL, 1, '''N''', 'N', 'N'
, 'N', 'Y', NULL, 'N', 0, 'N', 'N', NULL, NULL, NULL, NULL, 'N', 53206
, NULL, 'N', 'N', NULL); 


/* Separator */
ALTER TABLE AD_Sequence ADD Separator CHAR(1);

INSERT INTO AD_COLUMN ( AD_COLUMN_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, UPDATED,
CREATEDBY, UPDATEDBY, NAME, DESCRIPTION, HELP, VERSION, ENTITYTYPE, COLUMNNAME, AD_TABLE_ID,
AD_REFERENCE_ID, AD_REFERENCE_VALUE_ID, AD_VAL_RULE_ID, FIELDLENGTH, DEFAULTVALUE, ISKEY, ISPARENT,
ISMANDATORY, ISUPDATEABLE, READONLYLOGIC, ISIDENTIFIER, SEQNO, ISTRANSLATED, ISENCRYPTED, CALLOUT,
VFORMAT, VALUEMIN, VALUEMAX, ISSELECTIONCOLUMN, AD_ELEMENT_ID, AD_PROCESS_ID, ISSYNCDATABASE,
ISALWAYSUPDATEABLE, COLUMNSQL ) VALUES ( 
53207, 0, 0, 'Y',  TO_Date( '02/08/2007 02:21:12', 'MM/DD/YYYY HH:MI:SS')
,  TO_Date( '02/08/2007 02:21:12', 'MM/DD/YYYY HH:MI:SS'), 0, 0, 'Separator'
, NULL, NULL, 1, 'D', 'Separator', 115, 10, NULL, NULL, 1, NULL, 'N', 'N', 'N', 'Y'
, NULL, 'N', 0, 'N', 'N', NULL, NULL, NULL, NULL, 'N', 565, NULL, 'N', 'N', NULL); 


/* DatePosition */
ALTER TABLE AD_Sequence ADD DatePosition CHAR(2);

INSERT INTO AD_ELEMENT ( AD_ELEMENT_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY,
UPDATED, UPDATEDBY, COLUMNNAME, ENTITYTYPE, NAME, PRINTNAME, DESCRIPTION, HELP, PO_NAME,
PO_PRINTNAME, PO_DESCRIPTION, PO_HELP ) VALUES ( 
53208, 0, 0, 'Y',  TO_Date( '02/08/2007 02:21:58', 'MM/DD/YYYY HH:MI:SS')
, 0,  TO_Date( '02/08/2007 02:27:55', 'MM/DD/YYYY HH:MI:SS'), 0, 'DatePosition'
, 'D', 'Date Position', 'Date Position', NULL, NULL, NULL, NULL, NULL, NULL); 

/* ------------------------------------------------------------------------------------------- */
/* Reference  = SP Date Position */
INSERT INTO AD_REFERENCE ( AD_REFERENCE_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY,
UPDATED, UPDATEDBY, NAME, DESCRIPTION, HELP, VALIDATIONTYPE, VFORMAT,
ENTITYTYPE ) VALUES ( 
53200, 0, 0, 'Y',  TO_Date( '02/08/2007 02:23:19', 'MM/DD/YYYY HH:MI:SS')
, 0,  TO_Date( '02/08/2007 02:25:54', 'MM/DD/YYYY HH:MI:SS'), 0, 'SP Date Position'
, NULL, NULL, 'L', NULL, 'D'); 

/* Reference List  =  After Prefix */
INSERT INTO AD_REF_LIST ( AD_REF_LIST_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY,
UPDATED, UPDATEDBY, VALUE, NAME, DESCRIPTION, AD_REFERENCE_ID, VALIDFROM, VALIDTO,
ENTITYTYPE ) VALUES ( 
53200, 0, 0, 'Y',  TO_Date( '02/08/2007 02:26:24', 'MM/DD/YYYY HH:MI:SS')
, 0,  TO_Date( '02/08/2007 02:26:24', 'MM/DD/YYYY HH:MI:SS'), 0, 'AP', 'After Prefix'
, NULL, 53200, NULL, NULL, 'D'); 

/* Reference List  =  After Suffix */
INSERT INTO AD_REF_LIST ( AD_REF_LIST_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY,
UPDATED, UPDATEDBY, VALUE, NAME, DESCRIPTION, AD_REFERENCE_ID, VALIDFROM, VALIDTO,
ENTITYTYPE ) VALUES ( 
53201, 0, 0, 'Y',  TO_Date( '02/08/2007 02:26:38', 'MM/DD/YYYY HH:MI:SS')
, 0,  TO_Date( '02/08/2007 02:26:38', 'MM/DD/YYYY HH:MI:SS'), 0, 'AS', 'After Suffix'
, NULL, 53200, NULL, NULL, 'D'); 

/* Reference List  =  Before Prefix */
INSERT INTO AD_REF_LIST ( AD_REF_LIST_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY,
UPDATED, UPDATEDBY, VALUE, NAME, DESCRIPTION, AD_REFERENCE_ID, VALIDFROM, VALIDTO,
ENTITYTYPE ) VALUES ( 
53202, 0, 0, 'Y',  TO_Date( '02/08/2007 02:27:04', 'MM/DD/YYYY HH:MI:SS')
, 0,  TO_Date( '02/08/2007 02:27:04', 'MM/DD/YYYY HH:MI:SS'), 0, 'BP', 'Before Prefix'
, NULL, 53200, NULL, NULL, 'D'); 

/* Reference List  =  Before Suffix */
INSERT INTO AD_REF_LIST ( AD_REF_LIST_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY,
UPDATED, UPDATEDBY, VALUE, NAME, DESCRIPTION, AD_REFERENCE_ID, VALIDFROM, VALIDTO,
ENTITYTYPE ) VALUES ( 
53203, 0, 0, 'Y',  TO_Date( '02/08/2007 02:27:16', 'MM/DD/YYYY HH:MI:SS')
, 0,  TO_Date( '02/08/2007 02:27:16', 'MM/DD/YYYY HH:MI:SS'), 0, 'BS', 'Before Suffix'
, NULL, 53200, NULL, NULL, 'D'); 
/* ------------------------------------------------------------------------------------------- */

INSERT INTO AD_COLUMN ( AD_COLUMN_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, UPDATED,
CREATEDBY, UPDATEDBY, NAME, DESCRIPTION, HELP, VERSION, ENTITYTYPE, COLUMNNAME, AD_TABLE_ID,
AD_REFERENCE_ID, AD_REFERENCE_VALUE_ID, AD_VAL_RULE_ID, FIELDLENGTH, DEFAULTVALUE, ISKEY, ISPARENT,
ISMANDATORY, ISUPDATEABLE, READONLYLOGIC, ISIDENTIFIER, SEQNO, ISTRANSLATED, ISENCRYPTED, CALLOUT,
VFORMAT, VALUEMIN, VALUEMAX, ISSELECTIONCOLUMN, AD_ELEMENT_ID, AD_PROCESS_ID, ISSYNCDATABASE,
ISALWAYSUPDATEABLE, COLUMNSQL ) VALUES ( 
53208, 0, 0, 'Y',  TO_Date( '02/08/2007 02:27:36', 'MM/DD/YYYY HH:MI:SS')
,  TO_Date( '02/08/2007 02:28:21', 'MM/DD/YYYY HH:MI:SS'), 0, 0, 'Date Position'
, NULL, NULL, 1, 'D', 'DatePosition', 115, 17, 53200
, NULL, 2, NULL, 'N', 'N', 'N', 'Y', NULL, 'N', 0, 'N', 'N', NULL, NULL, NULL, NULL, 'N'
, 53208
, NULL, 'N', 'N', NULL); 


/* DateFormat */
ALTER TABLE AD_Sequence ADD DateFormat CHAR(6);

/* ------------------------------------------------------------------------------------------- */
/* Reference = SP Date Format */
INSERT INTO AD_REFERENCE ( AD_REFERENCE_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY,
UPDATED, UPDATEDBY, NAME, DESCRIPTION, HELP, VALIDATIONTYPE, VFORMAT,
ENTITYTYPE ) VALUES ( 
53201, 0, 0, 'Y',  TO_Date( '02/08/2007 02:31:48', 'MM/DD/YYYY HH:MI:SS')
, 0,  TO_Date( '02/08/2007 02:31:48', 'MM/DD/YYYY HH:MI:SS'), 0, 'SP Date Format'
, NULL, NULL, 'L', NULL, 'D'); 

/* Reference List = MMddyy */
INSERT INTO AD_REF_LIST ( AD_REF_LIST_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY,
UPDATED, UPDATEDBY, VALUE, NAME, DESCRIPTION, AD_REFERENCE_ID, VALIDFROM, VALIDTO,
ENTITYTYPE ) VALUES ( 
53204, 0, 0, 'Y',  TO_Date( '02/08/2007 02:32:15', 'MM/DD/YYYY HH:MI:SS')
, 0,  TO_Date( '02/08/2007 02:32:15', 'MM/DD/YYYY HH:MI:SS'), 0, 'MMddyy', 'MMddyy'
, NULL, 53201, NULL, NULL, 'D'); 

/* Reference List = ddMMyy */
INSERT INTO AD_REF_LIST ( AD_REF_LIST_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY,
UPDATED, UPDATEDBY, VALUE, NAME, DESCRIPTION, AD_REFERENCE_ID, VALIDFROM, VALIDTO,
ENTITYTYPE ) VALUES ( 
53205, 0, 0, 'Y',  TO_Date( '02/08/2007 02:32:22', 'MM/DD/YYYY HH:MI:SS')
, 0,  TO_Date( '02/08/2007 02:32:22', 'MM/DD/YYYY HH:MI:SS'), 0, 'ddMMyy', 'ddMMyy'
, NULL, 53201, NULL, NULL, 'D'); 

/* Reference List = yyMMdd */
INSERT INTO AD_REF_LIST ( AD_REF_LIST_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY,
UPDATED, UPDATEDBY, VALUE, NAME, DESCRIPTION, AD_REFERENCE_ID, VALIDFROM, VALIDTO,
ENTITYTYPE ) VALUES ( 
53206, 0, 0, 'Y',  TO_Date( '02/08/2007 02:32:32', 'MM/DD/YYYY HH:MI:SS')
, 0,  TO_Date( '02/08/2007 02:32:32', 'MM/DD/YYYY HH:MI:SS'), 0, 'yyMMdd', 'yyMMdd'
, NULL, 53201, NULL, NULL, 'D'); 
/* ------------------------------------------------------------------------------------------- */

INSERT INTO AD_COLUMN ( AD_COLUMN_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, UPDATED,
CREATEDBY, UPDATEDBY, NAME, DESCRIPTION, HELP, VERSION, ENTITYTYPE, COLUMNNAME, AD_TABLE_ID,
AD_REFERENCE_ID, AD_REFERENCE_VALUE_ID, AD_VAL_RULE_ID, FIELDLENGTH, DEFAULTVALUE, ISKEY, ISPARENT,
ISMANDATORY, ISUPDATEABLE, READONLYLOGIC, ISIDENTIFIER, SEQNO, ISTRANSLATED, ISENCRYPTED, CALLOUT,
VFORMAT, VALUEMIN, VALUEMAX, ISSELECTIONCOLUMN, AD_ELEMENT_ID, AD_PROCESS_ID, ISSYNCDATABASE,
ISALWAYSUPDATEABLE, COLUMNSQL ) VALUES ( 
53209, 0, 0, 'Y',  TO_Date( '02/08/2007 02:33:06', 'MM/DD/YYYY HH:MI:SS')
,  TO_Date( '02/08/2007 02:33:06', 'MM/DD/YYYY HH:MI:SS'), 0, 0, 'Date Format'
, NULL, NULL, 1, 'D', 'DateFormat', 115, 17, 53201
, NULL, 6, NULL, 'N', 'N', 'N', 'Y', NULL, 'N', 0, 'N', 'N', NULL, NULL, NULL, NULL, 'N', 2286, NULL, 'N', 'N', NULL); 


/* Reset */
ALTER TABLE AD_Sequence ADD Reset CHAR(1);

INSERT INTO AD_ELEMENT ( AD_ELEMENT_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY,
UPDATED, UPDATEDBY, COLUMNNAME, ENTITYTYPE, NAME, PRINTNAME, DESCRIPTION, HELP, PO_NAME,
PO_PRINTNAME, PO_DESCRIPTION, PO_HELP ) VALUES ( 
53210, 0, 0, 'Y',  TO_Date( '02/08/2007 02:45:18', 'MM/DD/YYYY HH:MI:SS')
, 0,  TO_Date( '02/08/2007 02:45:18', 'MM/DD/YYYY HH:MI:SS'), 0, 'Reset', 'D'
, 'Reset', 'Reset', NULL, NULL, NULL, NULL, NULL, NULL); 

/* ------------------------------------------------------------------------------------------- */
/* Reference = SP Reset */
INSERT INTO AD_REFERENCE ( AD_REFERENCE_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY,
UPDATED, UPDATEDBY, NAME, DESCRIPTION, HELP, VALIDATIONTYPE, VFORMAT,
ENTITYTYPE ) VALUES ( 
53202, 0, 0, 'Y',  TO_Date( '02/08/2007 02:46:01', 'MM/DD/YYYY HH:MI:SS')
, 0,  TO_Date( '02/08/2007 02:46:01', 'MM/DD/YYYY HH:MI:SS'), 0, 'SP Reset'
, NULL, NULL, 'L', NULL, 'D'); 

/* Reference List = Every Day */
INSERT INTO AD_REF_LIST ( AD_REF_LIST_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY,
UPDATED, UPDATEDBY, VALUE, NAME, DESCRIPTION, AD_REFERENCE_ID, VALIDFROM, VALIDTO,
ENTITYTYPE ) VALUES ( 
53207, 0, 0, 'Y',  TO_Date( '02/08/2007 02:46:20', 'MM/DD/YYYY HH:MI:SS')
, 0,  TO_Date( '02/08/2007 02:46:20', 'MM/DD/YYYY HH:MI:SS'), 0, 'd', 'Every Day'
, NULL, 53202, NULL, NULL, 'D'); 

/* Reference List = Every Month */
INSERT INTO AD_REF_LIST ( AD_REF_LIST_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY,
UPDATED, UPDATEDBY, VALUE, NAME, DESCRIPTION, AD_REFERENCE_ID, VALIDFROM, VALIDTO,
ENTITYTYPE ) VALUES ( 
53208, 0, 0, 'Y',  TO_Date( '02/08/2007 02:46:33', 'MM/DD/YYYY HH:MI:SS')
, 0,  TO_Date( '02/08/2007 02:46:33', 'MM/DD/YYYY HH:MI:SS'), 0, 'M', 'Every Month'
, NULL, 53202, NULL, NULL, 'D'); 

/* Reference List = Every Year */
INSERT INTO AD_REF_LIST ( AD_REF_LIST_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY,
UPDATED, UPDATEDBY, VALUE, NAME, DESCRIPTION, AD_REFERENCE_ID, VALIDFROM, VALIDTO,
ENTITYTYPE ) VALUES ( 
53209, 0, 0, 'Y',  TO_Date( '02/08/2007 02:46:40', 'MM/DD/YYYY HH:MI:SS')
, 0,  TO_Date( '02/08/2007 02:46:40', 'MM/DD/YYYY HH:MI:SS'), 0, 'y', 'Every Year'
, NULL, 53202, NULL, NULL, 'D'); 
/* ------------------------------------------------------------------------------------------- */

INSERT INTO AD_COLUMN ( AD_COLUMN_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, UPDATED,
CREATEDBY, UPDATEDBY, NAME, DESCRIPTION, HELP, VERSION, ENTITYTYPE, COLUMNNAME, AD_TABLE_ID,
AD_REFERENCE_ID, AD_REFERENCE_VALUE_ID, AD_VAL_RULE_ID, FIELDLENGTH, DEFAULTVALUE, ISKEY, ISPARENT,
ISMANDATORY, ISUPDATEABLE, READONLYLOGIC, ISIDENTIFIER, SEQNO, ISTRANSLATED, ISENCRYPTED, CALLOUT,
VFORMAT, VALUEMIN, VALUEMAX, ISSELECTIONCOLUMN, AD_ELEMENT_ID, AD_PROCESS_ID, ISSYNCDATABASE,
ISALWAYSUPDATEABLE, COLUMNSQL ) VALUES ( 
53210, 0, 0, 'Y',  TO_Date( '02/08/2007 02:47:04', 'MM/DD/YYYY HH:MI:SS')
,  TO_Date( '02/08/2007 02:47:04', 'MM/DD/YYYY HH:MI:SS'), 0, 0, 'Reset', NULL
, NULL, 1, 'D', 'Reset', 115, 17, 53202
, NULL, 1, NULL, 'N', 'N', 'N', 'Y', NULL, 'N', 0, 'N', 'N', NULL, NULL, NULL, NULL, 'N'
, 53210
, NULL, 'N', 'N', NULL); 


--
-- NOTE: don't forget to run add missing translations and sequence check